﻿IF object_id(N'dbo.TabAccountIndex', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[TabAccountIndex] (
        [UserID]   numeric(18,0) NOT NULL identity(1, 1),
        [UserName] nvarchar(20)  COLLATE Chinese_PRC_CI_AS NOT NULL,
        [Password] nvarchar(20)  COLLATE Chinese_PRC_CI_AS NOT NULL,

        CONSTRAINT [PK_TabUser] PRIMARY KEY CLUSTERED ([UserID] asc),
        CONSTRAINT [IX_TabUser] UNIQUE NONCLUSTERED ([UserName] asc)
    );
END
GO
